The star has previously been inducted with his band, Black Sabbath, and is one of a few including Sir Paul McCartney to have been given the honour.